How to: Find part of a value at the beginning of cell with Filter by Selection.
Solution:
In the Table Datasheet view, select the beginning of a field, and use the 'Filter By Selection' command on the 'Filter' submenu under the 'Records' menu.
1) If the Database window is not active, activate the Database window.
2) Go to the Table Datasheet view.
3) Select the beginning part of the desired word by clicking and dragging the mouse over it.
NOTE: When the beginning of a word or other entry in a cell is selected, the filter returns those records that contain a field beginning with that value.
EXAMPLE: In a table with a record containing the word 'Condiments' and another record containing the word 'Confections', selecting the 'Con' part of the word in one of the fields returns both records.
Beginning of field
4) Select the 'Records' menu and select 'Filter'. (A submenu appears.)
5) Select 'Filter By Selection' from the 'Filter' submenu. (Only records containing the value in the field selected in step 3) remain in the datasheet.)
6) To view all entries in the table again, select the 'Records' menu and select 'Remove Filter/Sort'.
7) To reapply the previous existing filter, select the 'Records' menu and select 'Apply Filter/Sort'.
